﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dedetestDataSet" targetNamespace="http://tempuri.org/dedetestDataSet.xsd" xmlns:mstns="http://tempuri.org/dedetestDataSet.xsd" xmlns="http://tempuri.org/dedetestDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MYSQLConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MYSQLConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.dataTOdedecms.Properties.Settings.GlobalReference.Default.MYSQLConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dede_addonarticleTableAdapter" GeneratorDataComponentClassName="dede_addonarticleTableAdapter" Name="dede_addonarticle" UserDataComponentName="dede_addonarticleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MYSQLConnectionString (Settings)" DbObjectName="dedetest.dede_addonarticle" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `dede_addonarticle` WHERE ((`aid` = @Original_aid) AND (`typeid` = @Original_typeid) AND (`redirecturl` = @Original_redirecturl) AND (`templet` = @Original_templet) AND (`userip` = @Original_userip) AND ((@IsNull_quyu = 1 AND `quyu` IS NULL) OR (`quyu` = @Original_quyu)) AND ((@IsNull_area = 1 AND `area` IS NULL) OR (`area` = @Original_area)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_aid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="aid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@Original_typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_redirecturl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="redirecturl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_templet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="templet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_userip" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="userip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quyu" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_quyu" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_area" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_area" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `dede_addonarticle` (`aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`, `quyu`, `area`) VALUES (@aid, @typeid, @body, @redirecturl, @templet, @userip, @quyu, @area)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@aid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="aid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@redirecturl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="redirecturl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@templet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="templet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userip" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="userip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@quyu" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@area" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`, `quyu`, `area` FROM `dede_addonarticle`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `dede_addonarticle` SET `aid` = @aid, `typeid` = @typeid, `body` = @body, `redirecturl` = @redirecturl, `templet` = @templet, `userip` = @userip, `quyu` = @quyu, `area` = @area WHERE ((`aid` = @Original_aid) AND (`typeid` = @Original_typeid) AND (`redirecturl` = @Original_redirecturl) AND (`templet` = @Original_templet) AND (`userip` = @Original_userip) AND ((@IsNull_quyu = 1 AND `quyu` IS NULL) OR (`quyu` = @Original_quyu)) AND ((@IsNull_area = 1 AND `area` IS NULL) OR (`area` = @Original_area)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@aid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="aid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@redirecturl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="redirecturl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@templet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="templet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userip" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="userip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@quyu" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@area" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_aid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="aid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@Original_typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_redirecturl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="redirecturl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_templet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="templet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_userip" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="userip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quyu" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_quyu" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="quyu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_area" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_area" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="area" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="aid" DataSetColumn="aid" />
              <Mapping SourceColumn="typeid" DataSetColumn="typeid" />
              <Mapping SourceColumn="body" DataSetColumn="body" />
              <Mapping SourceColumn="redirecturl" DataSetColumn="redirecturl" />
              <Mapping SourceColumn="templet" DataSetColumn="templet" />
              <Mapping SourceColumn="userip" DataSetColumn="userip" />
              <Mapping SourceColumn="quyu" DataSetColumn="quyu" />
              <Mapping SourceColumn="area" DataSetColumn="area" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dede_archivesTableAdapter" GeneratorDataComponentClassName="dede_archivesTableAdapter" Name="dede_archives" UserDataComponentName="dede_archivesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MYSQLConnectionString (Settings)" DbObjectName="dedetest.dede_archives" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `dede_archives` WHERE ((`id` = @Original_id) AND (`typeid` = @Original_typeid) AND (`typeid2` = @Original_typeid2) AND (`sortrank` = @Original_sortrank) AND ((@IsNull_flag = 1 AND `flag` IS NULL) OR (`flag` = @Original_flag)) AND (`ismake` = @Original_ismake) AND (`channel` = @Original_channel) AND (`arcrank` = @Original_arcrank) AND (`click` = @Original_click) AND (`money` = @Original_money) AND (`title` = @Original_title) AND (`shorttitle` = @Original_shorttitle) AND (`color` = @Original_color) AND (`writer` = @Original_writer) AND (`source` = @Original_source) AND (`litpic` = @Original_litpic) AND (`pubdate` = @Original_pubdate) AND (`senddate` = @Original_senddate) AND (`mid` = @Original_mid) AND (`keywords` = @Original_keywords) AND (`lastpost` = @Original_lastpost) AND (`scores` = @Original_scores) AND (`goodpost` = @Original_goodpost) AND (`badpost` = @Original_badpost) AND (`voteid` = @Original_voteid) AND (`notpost` = @Original_notpost) AND (`description` = @Original_description) AND (`filename` = @Original_filename) AND (`dutyadmin` = @Original_dutyadmin) AND (`tackid` = @Original_tackid) AND (`mtype` = @Original_mtype) AND (`weight` = @Original_weight))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@Original_typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_typeid2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="typeid2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_sortrank" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="sortrank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_flag" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_flag" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ismake" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="ismake" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_channel" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_arcrank" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="arcrank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_click" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="click" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_money" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="money" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_shorttitle" Precision="0" ProviderType="Guid" Scale="0" Size="0" SourceColumn="shorttitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_color" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_writer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="writer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_source" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="source" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_litpic" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="litpic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_pubdate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="pubdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_senddate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="senddate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_keywords" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keywords" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_lastpost" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="lastpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_scores" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="scores" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_goodpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="goodpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_badpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="badpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_voteid" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="voteid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_notpost" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="notpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="filename" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_dutyadmin" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="dutyadmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tackid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tackid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_mtype" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mtype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_weight" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `dede_archives` (`id`, `typeid`, `typeid2`, `sortrank`, `flag`, `ismake`, `channel`, `arcrank`, `click`, `money`, `title`, `shorttitle`, `color`, `writer`, `source`, `litpic`, `pubdate`, `senddate`, `mid`, `keywords`, `lastpost`, `scores`, `goodpost`, `badpost`, `voteid`, `notpost`, `description`, `filename`, `dutyadmin`, `tackid`, `mtype`, `weight`) VALUES (@id, @typeid, @typeid2, @sortrank, @flag, @ismake, @channel, @arcrank, @click, @money, @title, @shorttitle, @color, @writer, @source, @litpic, @pubdate, @senddate, @mid, @keywords, @lastpost, @scores, @goodpost, @badpost, @voteid, @notpost, @description, @filename, @dutyadmin, @tackid, @mtype, @weight)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeid2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="typeid2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@sortrank" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="sortrank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@flag" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ismake" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="ismake" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@channel" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@arcrank" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="arcrank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@click" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="click" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@money" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="money" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@title" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@shorttitle" Precision="0" ProviderType="Guid" Scale="0" Size="0" SourceColumn="shorttitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@color" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@writer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="writer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@source" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="source" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@litpic" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="litpic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@pubdate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="pubdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@senddate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="senddate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@keywords" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keywords" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@lastpost" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="lastpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@scores" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="scores" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@goodpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="goodpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@badpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="badpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@voteid" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="voteid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@notpost" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="notpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="filename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@dutyadmin" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="dutyadmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tackid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tackid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@mtype" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@weight" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `id`, `typeid`, `typeid2`, `sortrank`, `flag`, `ismake`, `channel`, `arcrank`, `click`, `money`, `title`, `shorttitle`, `color`, `writer`, `source`, `litpic`, `pubdate`, `senddate`, `mid`, `keywords`, `lastpost`, `scores`, `goodpost`, `badpost`, `voteid`, `notpost`, `description`, `filename`, `dutyadmin`, `tackid`, `mtype`, `weight` FROM `dede_archives`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `dede_archives` SET `id` = @id, `typeid` = @typeid, `typeid2` = @typeid2, `sortrank` = @sortrank, `flag` = @flag, `ismake` = @ismake, `channel` = @channel, `arcrank` = @arcrank, `click` = @click, `money` = @money, `title` = @title, `shorttitle` = @shorttitle, `color` = @color, `writer` = @writer, `source` = @source, `litpic` = @litpic, `pubdate` = @pubdate, `senddate` = @senddate, `mid` = @mid, `keywords` = @keywords, `lastpost` = @lastpost, `scores` = @scores, `goodpost` = @goodpost, `badpost` = @badpost, `voteid` = @voteid, `notpost` = @notpost, `description` = @description, `filename` = @filename, `dutyadmin` = @dutyadmin, `tackid` = @tackid, `mtype` = @mtype, `weight` = @weight WHERE ((`id` = @Original_id) AND (`typeid` = @Original_typeid) AND (`typeid2` = @Original_typeid2) AND (`sortrank` = @Original_sortrank) AND ((@IsNull_flag = 1 AND `flag` IS NULL) OR (`flag` = @Original_flag)) AND (`ismake` = @Original_ismake) AND (`channel` = @Original_channel) AND (`arcrank` = @Original_arcrank) AND (`click` = @Original_click) AND (`money` = @Original_money) AND (`title` = @Original_title) AND (`shorttitle` = @Original_shorttitle) AND (`color` = @Original_color) AND (`writer` = @Original_writer) AND (`source` = @Original_source) AND (`litpic` = @Original_litpic) AND (`pubdate` = @Original_pubdate) AND (`senddate` = @Original_senddate) AND (`mid` = @Original_mid) AND (`keywords` = @Original_keywords) AND (`lastpost` = @Original_lastpost) AND (`scores` = @Original_scores) AND (`goodpost` = @Original_goodpost) AND (`badpost` = @Original_badpost) AND (`voteid` = @Original_voteid) AND (`notpost` = @Original_notpost) AND (`description` = @Original_description) AND (`filename` = @Original_filename) AND (`dutyadmin` = @Original_dutyadmin) AND (`tackid` = @Original_tackid) AND (`mtype` = @Original_mtype) AND (`weight` = @Original_weight))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeid2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="typeid2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@sortrank" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="sortrank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@flag" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ismake" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="ismake" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@channel" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@arcrank" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="arcrank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@click" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="click" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@money" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="money" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@title" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@shorttitle" Precision="0" ProviderType="Guid" Scale="0" Size="0" SourceColumn="shorttitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@color" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@writer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="writer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@source" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="source" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@litpic" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="litpic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@pubdate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="pubdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@senddate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="senddate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@keywords" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keywords" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@lastpost" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="lastpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@scores" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="scores" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@goodpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="goodpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@badpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="badpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@voteid" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="voteid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@notpost" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="notpost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="filename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@dutyadmin" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="dutyadmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tackid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tackid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@mtype" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@weight" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt16" Direction="Input" ParameterName="@Original_typeid" Precision="0" ProviderType="UInt16" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_typeid2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="typeid2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_sortrank" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="sortrank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_flag" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_flag" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="flag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ismake" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="ismake" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_channel" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="channel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_arcrank" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="arcrank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_click" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="click" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_money" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="money" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_shorttitle" Precision="0" ProviderType="Guid" Scale="0" Size="0" SourceColumn="shorttitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_color" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_writer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="writer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_source" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="source" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_litpic" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="litpic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_pubdate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="pubdate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_senddate" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="senddate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_keywords" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keywords" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_lastpost" Precision="0" ProviderType="UInt32" Scale="0" Size="0" SourceColumn="lastpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_scores" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="scores" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_goodpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="goodpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_badpost" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="badpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_voteid" Precision="0" ProviderType="Int24" Scale="0" Size="0" SourceColumn="voteid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_notpost" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="notpost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="filename" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_dutyadmin" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="dutyadmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tackid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tackid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="UInt32" Direction="Input" ParameterName="@Original_mtype" Precision="0" ProviderType="UInt24" Scale="0" Size="0" SourceColumn="mtype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_weight" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="typeid" DataSetColumn="typeid" />
              <Mapping SourceColumn="typeid2" DataSetColumn="typeid2" />
              <Mapping SourceColumn="sortrank" DataSetColumn="sortrank" />
              <Mapping SourceColumn="flag" DataSetColumn="flag" />
              <Mapping SourceColumn="ismake" DataSetColumn="ismake" />
              <Mapping SourceColumn="channel" DataSetColumn="channel" />
              <Mapping SourceColumn="arcrank" DataSetColumn="arcrank" />
              <Mapping SourceColumn="click" DataSetColumn="click" />
              <Mapping SourceColumn="money" DataSetColumn="money" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="shorttitle" DataSetColumn="shorttitle" />
              <Mapping SourceColumn="color" DataSetColumn="color" />
              <Mapping SourceColumn="writer" DataSetColumn="writer" />
              <Mapping SourceColumn="source" DataSetColumn="source" />
              <Mapping SourceColumn="litpic" DataSetColumn="litpic" />
              <Mapping SourceColumn="pubdate" DataSetColumn="pubdate" />
              <Mapping SourceColumn="senddate" DataSetColumn="senddate" />
              <Mapping SourceColumn="mid" DataSetColumn="mid" />
              <Mapping SourceColumn="keywords" DataSetColumn="keywords" />
              <Mapping SourceColumn="lastpost" DataSetColumn="lastpost" />
              <Mapping SourceColumn="scores" DataSetColumn="scores" />
              <Mapping SourceColumn="goodpost" DataSetColumn="goodpost" />
              <Mapping SourceColumn="badpost" DataSetColumn="badpost" />
              <Mapping SourceColumn="voteid" DataSetColumn="voteid" />
              <Mapping SourceColumn="notpost" DataSetColumn="notpost" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="filename" DataSetColumn="filename" />
              <Mapping SourceColumn="dutyadmin" DataSetColumn="dutyadmin" />
              <Mapping SourceColumn="tackid" DataSetColumn="tackid" />
              <Mapping SourceColumn="mtype" DataSetColumn="mtype" />
              <Mapping SourceColumn="weight" DataSetColumn="weight" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dedetestDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dedetestDataSet" msprop:Generator_UserDSName="dedetestDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dede_addonarticle" msprop:Generator_TableClassName="dede_addonarticleDataTable" msprop:Generator_TableVarName="tabledede_addonarticle" msprop:Generator_TablePropName="dede_addonarticle" msprop:Generator_RowDeletingName="dede_addonarticleRowDeleting" msprop:Generator_UserTableName="dede_addonarticle" msprop:Generator_RowChangingName="dede_addonarticleRowChanging" msprop:Generator_RowEvHandlerName="dede_addonarticleRowChangeEventHandler" msprop:Generator_RowDeletedName="dede_addonarticleRowDeleted" msprop:Generator_RowEvArgName="dede_addonarticleRowChangeEvent" msprop:Generator_RowChangedName="dede_addonarticleRowChanged" msprop:Generator_RowClassName="dede_addonarticleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="aid" msprop:Generator_ColumnVarNameInTable="columnaid" msprop:Generator_ColumnPropNameInRow="aid" msprop:Generator_ColumnPropNameInTable="aidColumn" msprop:Generator_UserColumnName="aid" type="xs:unsignedInt" />
              <xs:element name="typeid" msprop:Generator_ColumnVarNameInTable="columntypeid" msprop:Generator_ColumnPropNameInRow="typeid" msprop:Generator_ColumnPropNameInTable="typeidColumn" msprop:Generator_UserColumnName="typeid" type="xs:unsignedShort" />
              <xs:element name="body" msprop:Generator_ColumnVarNameInTable="columnbody" msprop:Generator_ColumnPropNameInRow="body" msprop:Generator_ColumnPropNameInTable="bodyColumn" msprop:Generator_UserColumnName="body" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8388607" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="redirecturl" msprop:Generator_ColumnVarNameInTable="columnredirecturl" msprop:Generator_ColumnPropNameInRow="redirecturl" msprop:Generator_ColumnPropNameInTable="redirecturlColumn" msprop:Generator_UserColumnName="redirecturl">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="templet" msprop:Generator_ColumnVarNameInTable="columntemplet" msprop:Generator_ColumnPropNameInRow="templet" msprop:Generator_ColumnPropNameInTable="templetColumn" msprop:Generator_UserColumnName="templet">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="userip" msprop:Generator_ColumnVarNameInTable="columnuserip" msprop:Generator_ColumnPropNameInRow="userip" msprop:Generator_ColumnPropNameInTable="useripColumn" msprop:Generator_UserColumnName="userip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quyu" msprop:Generator_ColumnVarNameInTable="columnquyu" msprop:Generator_ColumnPropNameInRow="quyu" msprop:Generator_ColumnPropNameInTable="quyuColumn" msprop:Generator_UserColumnName="quyu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="area" msprop:Generator_ColumnVarNameInTable="columnarea" msprop:Generator_ColumnPropNameInRow="area" msprop:Generator_ColumnPropNameInTable="areaColumn" msprop:Generator_UserColumnName="area" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dede_archives" msprop:Generator_TableClassName="dede_archivesDataTable" msprop:Generator_TableVarName="tabledede_archives" msprop:Generator_TablePropName="dede_archives" msprop:Generator_RowDeletingName="dede_archivesRowDeleting" msprop:Generator_UserTableName="dede_archives" msprop:Generator_RowChangingName="dede_archivesRowChanging" msprop:Generator_RowEvHandlerName="dede_archivesRowChangeEventHandler" msprop:Generator_RowDeletedName="dede_archivesRowDeleted" msprop:Generator_RowEvArgName="dede_archivesRowChangeEvent" msprop:Generator_RowChangedName="dede_archivesRowChanged" msprop:Generator_RowClassName="dede_archivesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:unsignedInt" />
              <xs:element name="typeid" msprop:Generator_ColumnVarNameInTable="columntypeid" msprop:Generator_ColumnPropNameInRow="typeid" msprop:Generator_ColumnPropNameInTable="typeidColumn" msprop:Generator_UserColumnName="typeid" type="xs:unsignedShort" />
              <xs:element name="typeid2" msprop:Generator_ColumnVarNameInTable="columntypeid2" msprop:Generator_ColumnPropNameInRow="typeid2" msprop:Generator_ColumnPropNameInTable="typeid2Column" msprop:Generator_UserColumnName="typeid2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="90" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sortrank" msprop:Generator_ColumnVarNameInTable="columnsortrank" msprop:Generator_ColumnPropNameInRow="sortrank" msprop:Generator_ColumnPropNameInTable="sortrankColumn" msprop:Generator_UserColumnName="sortrank" type="xs:unsignedInt" />
              <xs:element name="flag" msprop:Generator_ColumnVarNameInTable="columnflag" msprop:Generator_ColumnPropNameInRow="flag" msprop:Generator_ColumnPropNameInTable="flagColumn" msprop:Generator_UserColumnName="flag" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ismake" msprop:Generator_ColumnVarNameInTable="columnismake" msprop:Generator_ColumnPropNameInRow="ismake" msprop:Generator_ColumnPropNameInTable="ismakeColumn" msprop:Generator_UserColumnName="ismake" type="xs:short" />
              <xs:element name="channel" msprop:Generator_ColumnVarNameInTable="columnchannel" msprop:Generator_ColumnPropNameInRow="channel" msprop:Generator_ColumnPropNameInTable="channelColumn" msprop:Generator_UserColumnName="channel" type="xs:short" />
              <xs:element name="arcrank" msprop:Generator_ColumnVarNameInTable="columnarcrank" msprop:Generator_ColumnPropNameInRow="arcrank" msprop:Generator_ColumnPropNameInTable="arcrankColumn" msprop:Generator_UserColumnName="arcrank" type="xs:short" />
              <xs:element name="click" msprop:Generator_ColumnVarNameInTable="columnclick" msprop:Generator_ColumnPropNameInRow="click" msprop:Generator_ColumnPropNameInTable="clickColumn" msprop:Generator_UserColumnName="click" type="xs:unsignedInt" />
              <xs:element name="money" msprop:Generator_ColumnVarNameInTable="columnmoney" msprop:Generator_ColumnPropNameInRow="money" msprop:Generator_ColumnPropNameInTable="moneyColumn" msprop:Generator_UserColumnName="money" type="xs:short" />
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="shorttitle" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnshorttitle" msprop:Generator_ColumnPropNameInRow="shorttitle" msprop:Generator_ColumnPropNameInTable="shorttitleColumn" msprop:Generator_UserColumnName="shorttitle" type="xs:string" />
              <xs:element name="color" msprop:Generator_ColumnVarNameInTable="columncolor" msprop:Generator_ColumnPropNameInRow="color" msprop:Generator_ColumnPropNameInTable="colorColumn" msprop:Generator_UserColumnName="color">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="writer" msprop:Generator_ColumnVarNameInTable="columnwriter" msprop:Generator_ColumnPropNameInRow="writer" msprop:Generator_ColumnPropNameInTable="writerColumn" msprop:Generator_UserColumnName="writer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="source" msprop:Generator_ColumnVarNameInTable="columnsource" msprop:Generator_ColumnPropNameInRow="source" msprop:Generator_ColumnPropNameInTable="sourceColumn" msprop:Generator_UserColumnName="source">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="litpic" msprop:Generator_ColumnVarNameInTable="columnlitpic" msprop:Generator_ColumnPropNameInRow="litpic" msprop:Generator_ColumnPropNameInTable="litpicColumn" msprop:Generator_UserColumnName="litpic">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pubdate" msprop:Generator_ColumnVarNameInTable="columnpubdate" msprop:Generator_ColumnPropNameInRow="pubdate" msprop:Generator_ColumnPropNameInTable="pubdateColumn" msprop:Generator_UserColumnName="pubdate" type="xs:unsignedInt" />
              <xs:element name="senddate" msprop:Generator_ColumnVarNameInTable="columnsenddate" msprop:Generator_ColumnPropNameInRow="senddate" msprop:Generator_ColumnPropNameInTable="senddateColumn" msprop:Generator_UserColumnName="senddate" type="xs:unsignedInt" />
              <xs:element name="mid" msprop:Generator_ColumnVarNameInTable="columnmid" msprop:Generator_ColumnPropNameInRow="mid" msprop:Generator_ColumnPropNameInTable="midColumn" msprop:Generator_UserColumnName="mid" type="xs:unsignedInt" />
              <xs:element name="keywords" msprop:Generator_ColumnVarNameInTable="columnkeywords" msprop:Generator_ColumnPropNameInRow="keywords" msprop:Generator_ColumnPropNameInTable="keywordsColumn" msprop:Generator_UserColumnName="keywords">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastpost" msprop:Generator_ColumnVarNameInTable="columnlastpost" msprop:Generator_ColumnPropNameInRow="lastpost" msprop:Generator_ColumnPropNameInTable="lastpostColumn" msprop:Generator_UserColumnName="lastpost" type="xs:unsignedInt" />
              <xs:element name="scores" msprop:Generator_ColumnVarNameInTable="columnscores" msprop:Generator_ColumnPropNameInRow="scores" msprop:Generator_ColumnPropNameInTable="scoresColumn" msprop:Generator_UserColumnName="scores" type="xs:int" />
              <xs:element name="goodpost" msprop:Generator_ColumnVarNameInTable="columngoodpost" msprop:Generator_ColumnPropNameInRow="goodpost" msprop:Generator_ColumnPropNameInTable="goodpostColumn" msprop:Generator_UserColumnName="goodpost" type="xs:unsignedInt" />
              <xs:element name="badpost" msprop:Generator_ColumnVarNameInTable="columnbadpost" msprop:Generator_ColumnPropNameInRow="badpost" msprop:Generator_ColumnPropNameInTable="badpostColumn" msprop:Generator_UserColumnName="badpost" type="xs:unsignedInt" />
              <xs:element name="voteid" msprop:Generator_ColumnVarNameInTable="columnvoteid" msprop:Generator_ColumnPropNameInRow="voteid" msprop:Generator_ColumnPropNameInTable="voteidColumn" msprop:Generator_UserColumnName="voteid" type="xs:int" />
              <xs:element name="notpost" msprop:Generator_ColumnVarNameInTable="columnnotpost" msprop:Generator_ColumnPropNameInRow="notpost" msprop:Generator_ColumnPropNameInTable="notpostColumn" msprop:Generator_UserColumnName="notpost" type="xs:unsignedByte" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="filename" msprop:Generator_ColumnVarNameInTable="columnfilename" msprop:Generator_ColumnPropNameInRow="filename" msprop:Generator_ColumnPropNameInTable="filenameColumn" msprop:Generator_UserColumnName="filename">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dutyadmin" msprop:Generator_ColumnVarNameInTable="columndutyadmin" msprop:Generator_ColumnPropNameInRow="dutyadmin" msprop:Generator_ColumnPropNameInTable="dutyadminColumn" msprop:Generator_UserColumnName="dutyadmin" type="xs:unsignedInt" />
              <xs:element name="tackid" msprop:Generator_ColumnVarNameInTable="columntackid" msprop:Generator_ColumnPropNameInRow="tackid" msprop:Generator_ColumnPropNameInTable="tackidColumn" msprop:Generator_UserColumnName="tackid" type="xs:int" />
              <xs:element name="mtype" msprop:Generator_ColumnVarNameInTable="columnmtype" msprop:Generator_ColumnPropNameInRow="mtype" msprop:Generator_ColumnPropNameInTable="mtypeColumn" msprop:Generator_UserColumnName="mtype" type="xs:unsignedInt" />
              <xs:element name="weight" msprop:Generator_ColumnVarNameInTable="columnweight" msprop:Generator_ColumnPropNameInRow="weight" msprop:Generator_ColumnPropNameInTable="weightColumn" msprop:Generator_UserColumnName="weight" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dede_addonarticle" />
      <xs:field xpath="mstns:aid" />
    </xs:unique>
    <xs:unique name="dede_archives_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dede_archives" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>